﻿CREATE PROCEDURE [dbo].[GetAllCategories]
@CategoryID INT=NULL
AS
SELECT 	CategoryID, 
		[Name], 
		Abbreviation,
		IsActive
FROM 		Categories
WHERE 	CategoryID = COALESCE(@CategoryID, CategoryID)
ORDER BY 	[Name]

